package com.oig.sys.base.entity;

import lombok.Getter;
import lombok.Setter;
import lombok.ToString;
import org.springframework.data.jpa.domain.support.AuditingEntityListener;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.EntityListeners;
import javax.persistence.Id;
import javax.persistence.Table;
import java.io.Serializable;


/**
 * @author wuxl
 * 海关港口表 只有启运港用到了国外港口
 */
@Getter
@Setter
@ToString
@Entity
@Table(name = "tb_port")
@EntityListeners({AuditingEntityListener.class})
public class TbPort implements Serializable {

	/**
	 */
	@Id
	@Column(name = "code", nullable = false)
	private String code;

	/**
	 */
	@Column(name = "name")
	private String name;

	/**
	 */
	@Column(name = "en_name")
	private String enName;

	/**
	 */
	@Column(name = "country_code")
	private String countryCode;

	/**
	 */
	@Column(name = "country_name")
	private String countryName;

	/**
	 * SAP维护的国家编码, 做冗余
	 */
	@Column(name = "country_apply_code", length = 6)
	private String countryApplyCode;

	/**
	 */
	@Column(name = "city_code")
	private String cityCode;

	/**
	 */
	@Column(name = "city_name")
	private String cityName;

	/**
	 */
	@Column(name = "address")
	private String address;

	/**
	 */
	@Column(name = "status")
	private String status;

	/**
	 */
	@Column(name = "sort")
	private Integer sort;

	@Column(name = "old_code")
	private String oldCode;

	// 口岸code
	@Column(name = "harbor_code")
	private String harborCode;

	// 口岸名称
	@Column(name = "harbor_name")
	private String harborName;

	// 海关code
	@Column(name = "customs_code")
	private String customsCode;

	// 海关名称
	@Column(name = "customs_name")
	private String customsName;
}
